/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package Administracion;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.NumberFormat;
import java.util.Date;
import java.util.Locale;

/**
 *
 * @author pato
 */
public class corte extends javax.swing.JInternalFrame {
local_connection conexion;
Connection cn; 
PreparedStatement ps;
ResultSet rs;
NumberFormat nf = NumberFormat.getCurrencyInstance(Locale.getDefault());
  String fI="", fF="",hI,hF;
    /**
     * Creates new form corte
     */
    public corte() {
        initComponents();
            jSpinField1.setMaximum(23);
        jSpinField1.setMinimum(0);
        jSpinField2.setMaximum(59);
        jSpinField2.setMinimum(0);
        jSpinField3.setMaximum(59);
        jSpinField3.setMinimum(0);
        jSpinField4.setMaximum(23);
        jSpinField4.setMinimum(0);
        jSpinField5.setMaximum(59);
        jSpinField5.setMinimum(0);
        jSpinField6.setMaximum(59);
        jSpinField6.setMinimum(0);       
    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jButton3 = new javax.swing.JButton();
        jDateChooser1 = new com.toedter.calendar.JDateChooser();
        jSpinField6 = new com.toedter.components.JSpinField();
        jLabel4 = new javax.swing.JLabel();
        jSpinField5 = new com.toedter.components.JSpinField();
        jLabel3 = new javax.swing.JLabel();
        jSpinField4 = new com.toedter.components.JSpinField();
        jLabel6 = new javax.swing.JLabel();
        jSpinField3 = new com.toedter.components.JSpinField();
        jLabel5 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel1 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jSpinField1 = new com.toedter.components.JSpinField();
        jSpinField2 = new com.toedter.components.JSpinField();
        jDateChooser2 = new com.toedter.calendar.JDateChooser();
        jLabel8 = new javax.swing.JLabel();
        ingresosc = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        utilidadt = new javax.swing.JLabel();
        gastos = new javax.swing.JLabel();
        ingresosp = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        egresosc = new javax.swing.JLabel();
        egresosp = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        utilidadc = new javax.swing.JLabel();
        utilidadp = new javax.swing.JLabel();
        jButton2 = new javax.swing.JButton();

        jButton3.setText("Obtener corte");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        jLabel4.setText(":");

        jLabel3.setText(":");

        jLabel6.setText(":");

        jLabel5.setText("Hora Fin:");

        jLabel2.setText(":");

        jLabel1.setText("Hora inicio:");

        jLabel9.setText("Fecha Final");

        jButton1.setText("Corte de Hoy");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jLabel8.setText("Fecha Inicio");

        ingresosc.setText("$0.00");

        jLabel7.setText("UtilidadT:");

        jLabel10.setText("Gastos:");

        jLabel11.setText("IngresosP:");

        jLabel12.setText("IngresosC:");

        utilidadt.setText("$0.00");

        gastos.setText("$0.00");

        ingresosp.setText("$0.00");

        jLabel13.setText("EgresosC: ");

        jLabel14.setText("EgresosP: ");

        egresosc.setText("$0.00");

        egresosp.setText("$0.00");

        jLabel15.setText("UtilidadC:  ");

        jLabel16.setText("UtilidadP:");

        utilidadc.setText("$0.00");

        utilidadp.setText("$0.00");

        jButton2.setText("Cerrar");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(layout.createSequentialGroup()
                                        .addGap(30, 30, 30)
                                        .addComponent(jLabel8))
                                    .addGroup(layout.createSequentialGroup()
                                        .addGap(39, 39, 39)
                                        .addComponent(jLabel9))
                                    .addGroup(layout.createSequentialGroup()
                                        .addContainerGap()
                                        .addComponent(jDateChooser1, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE))
                                    .addGroup(layout.createSequentialGroup()
                                        .addContainerGap()
                                        .addComponent(jDateChooser2, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)))
                                .addGap(8, 8, 8))
                            .addComponent(jButton1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 128, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addGap(4, 4, 4)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(layout.createSequentialGroup()
                                        .addGap(1, 1, 1)
                                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                            .addComponent(jLabel1)
                                            .addComponent(jLabel5)))
                                    .addGroup(layout.createSequentialGroup()
                                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                            .addGroup(layout.createSequentialGroup()
                                                .addComponent(jSpinField1, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                                .addComponent(jLabel2)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                                .addComponent(jSpinField2, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
                                            .addGroup(layout.createSequentialGroup()
                                                .addComponent(jSpinField4, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                                .addComponent(jLabel4)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                                .addComponent(jSpinField5, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                .addGap(4, 4, 4)))
                                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                            .addGroup(layout.createSequentialGroup()
                                                .addComponent(jLabel3)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                                .addComponent(jSpinField3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                            .addGroup(layout.createSequentialGroup()
                                                .addComponent(jLabel6)
                                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                                .addComponent(jSpinField6, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))))))
                            .addGroup(layout.createSequentialGroup()
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 128, javax.swing.GroupLayout.PREFERRED_SIZE))))
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 266, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(19, 19, 19)))
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(layout.createSequentialGroup()
                            .addGap(6, 6, 6)
                            .addComponent(jLabel7))
                        .addComponent(jLabel10, javax.swing.GroupLayout.Alignment.TRAILING))
                    .addComponent(jLabel12)
                    .addComponent(jLabel13)
                    .addComponent(jLabel11)
                    .addComponent(jLabel16, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel14)
                    .addComponent(jLabel15))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(egresosp, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(egresosc, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(ingresosp, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(utilidadc, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(gastos, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(utilidadt, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(ingresosc, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(utilidadp, javax.swing.GroupLayout.Alignment.TRAILING))
                .addContainerGap(51, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jLabel1)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                        .addComponent(jLabel2)
                                        .addComponent(jLabel3))
                                    .addComponent(jSpinField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addComponent(jSpinField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addComponent(jSpinField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jLabel8)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(jDateChooser1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(10, 10, 10)))
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel5)
                            .addComponent(jLabel9))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                .addComponent(jLabel4)
                                .addComponent(jLabel6))
                            .addComponent(jSpinField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jSpinField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jSpinField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jDateChooser2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(9, 9, 9)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel12)
                            .addComponent(ingresosc))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel11)
                            .addComponent(ingresosp))
                        .addGap(3, 3, 3)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel13)
                            .addComponent(egresosc))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel14)
                            .addComponent(egresosp))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel15)
                            .addComponent(utilidadc))))
                .addGap(7, 7, 7)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel16)
                            .addComponent(utilidadp))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel10, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(gastos))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel7)
                            .addComponent(utilidadt))
                        .addGap(0, 12, Short.MAX_VALUE))
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jButton3)
                            .addComponent(jButton1))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jButton2)))
                .addContainerGap())
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
float utilidad=0;
        String hI="00:00:00", hF="00:00:00";
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd ");
        if((jDateChooser1.getDate()!=null)&&(jDateChooser1.getDate()!=null))
        try {

            conexion = new local_connection();
            cn = conexion.getconnect();
            hI=String.valueOf(jSpinField1.getValue())+":"+String.valueOf(jSpinField2.getValue())+":"+String.valueOf(jSpinField3.getValue());
            hF=String.valueOf(jSpinField4.getValue())+":"+String.valueOf(jSpinField5.getValue())+":"+String.valueOf(jSpinField6.getValue());
            ps =   (PreparedStatement) cn.prepareStatement("select sum(preciovendido*cantidad),sum(detalleventa.preciocompra*cantidad) from detalleventa join venta on detalleventa.folio = venta.folio join productos on detalleventa.id_producto = productos.id_producto where productos.tipo = 'Curso' and venta.fecha between \""+sdf.format(jDateChooser1.getDate())+hI+"\" and \""+sdf.format(jDateChooser2.getDate())+hF+"\"");
            rs = ps.executeQuery();
            rs.next();
            if(rs.getObject(1)!=null)
           ingresosc.setText(nf.format(rs.getFloat(1)));
            egresosc.setText(nf.format(rs.getFloat(2)));;
            utilidadc.setText(nf.format(rs.getFloat(1)-rs.getFloat(2)));
            utilidad+=rs.getFloat(1)-rs.getFloat(2);
            ps =   (PreparedStatement) cn.prepareStatement("select sum(preciovendido*cantidad),sum(detalleventa.preciocompra*cantidad) from detalleventa join venta on detalleventa.folio = venta.folio join productos on detalleventa.id_producto = productos.id_producto where productos.tipo = 'Producto' and venta.fecha between \""+sdf.format(jDateChooser1.getDate())+hI+"\" and \""+sdf.format(jDateChooser2.getDate())+hF+"\"");
            rs = ps.executeQuery();
            rs.next();
            if(rs.getObject(1)!=null)
   ingresosp.setText(nf.format(rs.getFloat(1)));
            egresosp.setText(nf.format(rs.getFloat(2)));
            utilidad+=rs.getFloat(1)-rs.getFloat(2);
            utilidadp.setText(nf.format(rs.getFloat(1)-rs.getFloat(2)));
            ps =   (PreparedStatement) cn.prepareStatement("select sum(cantidad) from gastos where gastos.fecha between \""+sdf.format(jDateChooser1.getDate())+hI+"\" and \""+sdf.format(jDateChooser2.getDate())+hF+"\"");
            rs = ps.executeQuery();
            rs.next();
            if(rs.getObject(1)!=null){
            gastos.setText(nf.format(rs.getFloat(1)));
            utilidad-=rs.getFloat(1);}
            utilidadt.setText(nf.format(utilidad));
            //System.out.println(String.valueOf(rs.getObject(1)));
        }
        catch (SQLException ex) {
System.out.println(ex.getMessage());
        }

        // TODO add your handling code here:
    }//GEN-LAST:event_jButton3ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        float utilidad=0;
        java.util.Date hoy = new Date();
        try {

            conexion = new local_connection();
            cn = conexion.getconnect();
            ps =   (PreparedStatement) cn.prepareStatement("select sum(preciovendido*cantidad),sum(detalleventa.preciocompra*cantidad) from detalleventa join venta on detalleventa.folio = venta.folio join productos on detalleventa.id_producto = productos.id_producto where productos.tipo = 'Curso' and date(venta.fecha)=current_date");
            rs = ps.executeQuery();
            rs.next();
            if(rs.getObject(1)!=null)
            ingresosc.setText(nf.format(rs.getFloat(1)));
            egresosc.setText(nf.format(rs.getFloat(2)));;
            utilidadc.setText(nf.format(rs.getFloat(1)-rs.getFloat(2)));
            utilidad+=rs.getFloat(1)-rs.getFloat(2);
            ps =   (PreparedStatement) cn.prepareStatement("select sum(preciovendido*cantidad),sum(detalleventa.preciocompra*cantidad) from detalleventa join venta on detalleventa.folio = venta.folio join productos on detalleventa.id_producto = productos.id_producto where productos.tipo = 'Producto' and date(venta.fecha)=current_date");
            rs = ps.executeQuery();
            rs.next();
            if(rs.getObject(1)!=null)
            ingresosp.setText(nf.format(rs.getFloat(1)));
            egresosp.setText(nf.format(rs.getFloat(2)));
            utilidad+=rs.getFloat(1)-rs.getFloat(2);
            utilidadp.setText(nf.format(rs.getFloat(1)-rs.getFloat(2)));
            ps =   (PreparedStatement) cn.prepareStatement("select sum(cantidad) from gastos where date(fecha)=current_date");
            rs = ps.executeQuery();
            rs.next();
            if(rs.getObject(1)!=null){
            gastos.setText(nf.format(rs.getFloat(1)));
            utilidad-=rs.getFloat(1);}
            utilidadt.setText(nf.format(utilidad));
           //System.out.println(String.valueOf(rs.getObject(1)));
        }
        catch (SQLException ex) {
            System.out.println(ex.getMessage());
        }
        // TODO add your handling code here:
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
this.dispose();
        // TODO add your handling code here:
    }//GEN-LAST:event_jButton2ActionPerformed

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JLabel egresosc;
    private javax.swing.JLabel egresosp;
    private javax.swing.JLabel gastos;
    private javax.swing.JLabel ingresosc;
    private javax.swing.JLabel ingresosp;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private com.toedter.calendar.JDateChooser jDateChooser1;
    private com.toedter.calendar.JDateChooser jDateChooser2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private com.toedter.components.JSpinField jSpinField1;
    private com.toedter.components.JSpinField jSpinField2;
    private com.toedter.components.JSpinField jSpinField3;
    private com.toedter.components.JSpinField jSpinField4;
    private com.toedter.components.JSpinField jSpinField5;
    private com.toedter.components.JSpinField jSpinField6;
    private javax.swing.JLabel utilidadc;
    private javax.swing.JLabel utilidadp;
    private javax.swing.JLabel utilidadt;
    // End of variables declaration//GEN-END:variables
}
